package com.changgou.goods.dao;

import com.changgou.goods.pojo.Brand;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import tk.mybatis.mapper.common.Mapper;

import java.util.List;

public interface BrandMapper extends Mapper<Brand> {


    @Select("select tb_brand.name,tb_brand.image from tb_brand where tb_brand.id \n" +
            "in(SELECT tb_category_brand.brand_id from tb_category_brand where tb_category_brand.category_id in (select\n" +
            "tb_category.id FROM tb_category where tb_category.name=#{categoryName}))")
    public List<Brand> findListByCategoryName(@Param("categoryName") String categoryName);
}
